package com.lqd.mall.interaction.system;

import com.fasterxml.jackson.annotation.JsonFormat;
import com.lqd.mall.interaction.annotation.Excel;
import com.lqd.mall.interaction.annotation.Excel.ColumnType;
import com.lqd.mall.interaction.basis.BasisEntity;
import lombok.Getter;
import lombok.Setter;
import lombok.experimental.Accessors;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.io.Serializable;
import java.util.Date;

/**
 * @author 零起点
 * @create 2022-02-13 10:41
 */
@Setter
@Getter
@Entity
@Accessors(chain = true)
@Table(name = "sys_logininfor")
public class SysLogininforEntity  implements Serializable {

    private static final long serialVersionUID = 1L;

    /** ID */
    @Excel(name = "序号", cellType = ColumnType.NUMERIC)
    @Id
    @Column(name = "info_id")
    @GeneratedValue(strategy= GenerationType.IDENTITY)
    private Long infoId;

    /** 用户账号 */
    @Excel(name = "用户账号")
    @Column(name = "user_name")
    private String userName;

    /** 登录状态 0成功 1失败 */
    @Column(name = "status")
    @Excel(name = "登录状态", readConverterExp = "0=成功,1=失败")
    private String status;

    /** 登录IP地址 */
    @Excel(name = "登录地址")
    @Column(name = "ipaddr")
    private String ipaddr;

    /** 登录地点 */
    @Excel(name = "登录地点")
    @Column(name = "login_location")
    private String loginLocation;

    /** 浏览器类型 */
    @Excel(name = "浏览器")
    @Column(name = "browser")
    private String browser;

    /** 操作系统 */
    @Excel(name = "操作系统")
    @Column(name = "os")
    private String os;

    /** 提示消息 */
    @Excel(name = "提示消息")
    @Column(name = "msg")
    private String msg;

    /** 访问时间 */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "访问时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    @Column(name = "login_time")
    private Date loginTime;

}
